<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<meta name="generator" content=
"HTML Tidy for Windows (vers 14 February 2006), see www.w3.org" />
<title>Reconditioned Machines</title>
<link rel="stylesheet" href="home.css" type="text/css" media="screen" />
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>

</head>
<body>
<div class="page"><?php include 'menu.php';?>
<center>
<div class="content">


<table>
<tr>
<td class="pageTitle">RECONDITIONED MACHINES</td>
</tr>
</table>
<p><b>All of our reconditioned pressure washers have been
extensively tested to give you trouble-free performance. We only
offer equipment that we can be proud to sell.</b></p>
<p><b>All units have a minimum 30-day warranty. New parts carry up
to a 5-year warranty.</b></p>
<p><b>This page is updated about once a month, so <a href="about.php">please call</a> for
current information. This page was last updated <strong class=
"brand">

<?php

  // Connect to the database server
  $dbcnx = @mysql_connect("localhost", "root", "winter11");
  if (!$dbcnx) {
    echo( "<P>Unable to connect to the " .
          "database server at this time.</P>" );
    exit();
  }

  // Select the hydroclean database
  if (! @mysql_select_db("hydroclean") ) {
    echo( "<P>Unable to locate the Hydroclean " .
          "database at this time.</P>" );
    exit();
  }

  // Request the update date
  $updateLog = mysql_query("SELECT date FROM updateLog WHERE recondUpdate='1' ORDER BY date DESC");
  if (!$updateLog) {
    echo( "<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

  $lastUpdate = mysql_fetch_array($updateLog);
  echo($lastUpdate["date"]);

?>

</strong>.</b></p>
<p><b>-CLICK PICTURE TO ENLARGE-</b></p>
</center>

<center>
<table class="reconditioned" width="770px">
<tr>
<td class="majHeading" width="10%">UNIT #</td>
<td class="majHeading" width="75%">UNIT INFORMATION</td>
<td class="majHeading" width="10%">PRICE</td>
<td class="majHeading" width="5%">
<center><img src="images/photo.gif" alt="" /></center>
</td>
</tr>

<?php
  
  // Request the categories
  $cats = mysql_query(
            "SELECT * FROM category_xref");
  if (!$cats) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

  // Display the column headings
  while ( $catRow = mysql_fetch_array($cats) ) {

    echo("<tr><td colspan='4' class='minHeading'>" . $catRow["Description"] . "</td></tr>"); 

    // Request the machines for this category
    $machines = mysql_query(
	  	"SELECT * FROM reconditioned WHERE category = " . $catRow["catCode"] . " ORDER BY price ASC");
    if (!$machines) {
      echo("<P>Error performing query: " .
           mysql_error() . "</P>");
      exit();
    }
    // Display each machine in this category

    $machineCount = 0;
    while ( $machineRow = mysql_fetch_array($machines) ) {
	$machineCount++;
	echo("<tr><td class='caps'>" . $machineRow["cowtag"] . "</td>");
	echo("<td class='caps'>" . $machineRow["description"] . "</td>");
	echo("<td width='20%'>$" . $machineRow["price"] . "</td>");
	if (!empty($machineRow["piclink"]) && !empty($machineRow["piclink"])) { //only display a picture if it exists
	  echo("<td align='center'><a href='" . $machineRow["piclink"] . "' rel='lightbox[reconditioned]' title='" . strtoupper($machineRow["cowtag"]) . " - " . strtoupper($machineRow["description"]) . "')\">");
	  echo("<img src=\"" . $machineRow["thumblink"] . "\" height='60' /></a></td></tr>");
	}
	else
	  echo("<td align='center'><img src='pictures/reconditioned/nopicthumb.jpg' height='60' /></td></tr>");
    }
    if ($machineCount == 0) 
        echo("<tr><td colspan='4' class='caps'>none available at this time</td></tr>");
  }

?>


</table>
</center>
</div>
<!-- Start of StatCounter Code -->
<script type="text/javascript" language="javascript">
//<![CDATA[
var sc_project=665525; 
var sc_partition=5; 
var sc_security="41df126d"; 
var sc_invisible=1; 
//]]>
</script> <script type="text/javascript" language="javascript" src=
"http://www.statcounter.com/counter/counter.js">
</script><noscript><a href="http://www.statcounter.com/" target=
"_blank"><img src=
"http://c6.statcounter.com/counter.php?sc_project=665525&amp;amp;java=0&amp;amp;security=41df126d&amp;amp;invisible=1"
alt="free site statistics" border="0" /></a></noscript> 
<!-- End of StatCounter Code -->
</div>
</body>
</html>
